Overview

Brought to you by YData

Dataset statistics

Number of variables	30
Number of observations	733863
Missing cells	28
Missing cells (%)	< 0.1%
Total size in memory	552.6 MiB
Average record size in memory	789.6 B

Variable types

Numeric	18
Text	11
Boolean	1

Alerts

`is_anomaly` is highly imbalanced (88.3%)	Imbalance
`subscriber_sim_count` is highly skewed (γ1 = 27.53600142)	Skewed
`pdv_avg_sims_per_customer` is highly skewed (γ1 = 20.48589947)	Skewed
`reconstruction_error` is highly skewed (γ1 = 28.40803767)	Skewed
`msisdn` has unique values	Unique
`activation_dayofweek` has 109831 (15.0%) zeros	Zeros
`same_wilaya` has 68752 (9.4%) zeros	Zeros
`wilaya_code_diff` has 665111 (90.6%) zeros	Zeros
`days_since_pdv_first_activation` has 15549 (2.1%) zeros	Zeros
`time_phase_code` has 127073 (17.3%) zeros	Zeros
`pdv_multi_sim_pct` has 24230 (3.3%) zeros	Zeros

Reproduction

Analysis started	2025-04-28 00:04:10.687247
Analysis finished	2025-04-28 00:04:30.075565
Duration	19.39 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

msisdn
Real number (ℝ)

Unique

Distinct	733863
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	324843728.4

Minimum	300010025
Maximum	349740621
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	300010025
5-th percentile	302588400.4
Q1	312427645
median	324867641
Q3	337367331
95-th percentile	347287608.9
Maximum	349740621
Range	49730596
Interquartile range (IQR)	24939686

Descriptive statistics

Standard deviation	14373082.22
Coefficient of variation (CV)	0.0442461435
Kurtosis	-1.209513558
Mean	324843728.4
Median Absolute Deviation (MAD)	12469377
Skewness	0.007568724491
Sum	2.38390793 × 10¹⁴
Variance	2.065854926 × 10¹⁴
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
349740621	1	< 0.1%
300010025	1	< 0.1%
300010038	1	< 0.1%
300010052	1	< 0.1%
300010075	1	< 0.1%
300010082	1	< 0.1%
300010113	1	< 0.1%
349740378	1	< 0.1%
349740372	1	< 0.1%
349740371	1	< 0.1%
Other values (733853)	733853	> 99.9%

Value	Count	Frequency (%)
300010025	1	< 0.1%
300010038	1	< 0.1%
300010052	1	< 0.1%
300010075	1	< 0.1%
300010082	1	< 0.1%

Value	Count	Frequency (%)
349740621	1	< 0.1%
349740612	1	< 0.1%
349740608	1	< 0.1%
349740602	1	< 0.1%
349740574	1	< 0.1%

activation_date
Text

Distinct	666321
Distinct (%)	90.8%
Missing	0
Missing (%)	0.0%
Memory size	47.6 MiB

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	13943397
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	604980 ?
Unique (%)	82.4%

Sample

1st row	2025-01-29 10:56:38
2nd row	2025-03-06 11:18:09
3rd row	2025-03-14 22:48:23
4th row	2025-02-22 11:54:44
5th row	2025-02-02 14:36:33

Value	Count	Frequency (%)
2025-02-27	14715	1.0%
2025-01-30	14006	1.0%
2025-02-28	12739	0.9%
2025-03-30	12693	0.9%
2025-02-20	12313	0.8%
2025-03-29	12229	0.8%
2025-01-29	11965	0.8%
2025-02-26	11711	0.8%
2025-04-05	10669	0.7%
2025-02-16	10425	0.7%
Other values (62929)	1344261	91.6%

Most occurring characters

Value	Count	Frequency (%)
2	2663710	19.1%
0	2273812	16.3%
1	1540589	11.0%
-	1467726	10.5%
:	1467726	10.5%
5	1262125	9.1%
3	792468	5.7%
	733863	5.3%
4	560640	4.0%
7	304087	2.2%
Other values (3)	876651	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13943397	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	2663710	19.1%
0	2273812	16.3%
1	1540589	11.0%
-	1467726	10.5%
:	1467726	10.5%
5	1262125	9.1%
3	792468	5.7%
	733863	5.3%
4	560640	4.0%
7	304087	2.2%
Other values (3)	876651	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13943397	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	2663710	19.1%
0	2273812	16.3%
1	1540589	11.0%
-	1467726	10.5%
:	1467726	10.5%
5	1262125	9.1%
3	792468	5.7%
	733863	5.3%
4	560640	4.0%
7	304087	2.2%
Other values (3)	876651	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13943397	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	2663710	19.1%
0	2273812	16.3%
1	1540589	11.0%
-	1467726	10.5%
:	1467726	10.5%
5	1262125	9.1%
3	792468	5.7%
	733863	5.3%
4	560640	4.0%
7	304087	2.2%
Other values (3)	876651	6.3%

subscriber_wilaya
Text

Distinct	108
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.0 MiB

Length

Max length	19
Median length	18
Mean length	6.745381631
Min length	1

Characters and Unicode

Total characters	4950186
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	29 ?
Unique (%)	< 0.1%

Sample

1st row	ALGER
2nd row	OULED-DJELLAL
3rd row	CONSTANTINE
4th row	OUARGLA
5th row	BORDJ-BOU-ARRERIDJ

Value	Count	Frequency (%)
alger	144198	19.4%
constantine	52621	7.1%
setif	52303	7.0%
oran	35823	4.8%
chlef	34079	4.6%
blida	32901	4.4%
msila	30845	4.1%
djelfa	30188	4.1%
boumerdes	26949	3.6%
medea	20921	2.8%
Other values (102)	282960	38.0%

Most occurring characters

Value	Count	Frequency (%)
A	701683	14.2%
E	628949	12.7%
L	420535	8.5%
I	356128	7.2%
R	325070	6.6%
N	289129	5.8%
T	260154	5.3%
S	245806	5.0%
O	233486	4.7%
D	211222	4.3%
Other values (39)	1278024	25.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4950186	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	701683	14.2%
E	628949	12.7%
L	420535	8.5%
I	356128	7.2%
R	325070	6.6%
N	289129	5.8%
T	260154	5.3%
S	245806	5.0%
O	233486	4.7%
D	211222	4.3%
Other values (39)	1278024	25.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4950186	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	701683	14.2%
E	628949	12.7%
L	420535	8.5%
I	356128	7.2%
R	325070	6.6%
N	289129	5.8%
T	260154	5.3%
S	245806	5.0%
O	233486	4.7%
D	211222	4.3%
Other values (39)	1278024	25.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4950186	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	701683	14.2%
E	628949	12.7%
L	420535	8.5%
I	356128	7.2%
R	325070	6.6%
N	289129	5.8%
T	260154	5.3%
S	245806	5.0%
O	233486	4.7%
D	211222	4.3%
Other values (39)	1278024	25.8%

subscriber_id_number
Text

Distinct	610804
Distinct (%)	83.2%
Missing	0
Missing (%)	0.0%
Memory size	46.4 MiB

Length

Max length	20
Median length	18
Mean length	17.36415653
Min length	1

Characters and Unicode

Total characters	12742912
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	518154 ?
Unique (%)	70.6%

Sample

1st row	069182991590951419
2nd row	59048923899923990
3rd row	109778991590927189
4th row	715903991550999329
5th row	965546992559917639

Value	Count	Frequency (%)
959293	905	0.1%
993453	264	< 0.1%
5	144	< 0.1%
798154	68	< 0.1%
049316997590954889	50	< 0.1%
919316998299921489	46	< 0.1%
829302996590929029	44	< 0.1%
sj13319	39	< 0.1%
hd/0099/639	39	< 0.1%
959372992599995539	38	< 0.1%
Other values (610896)	732637	99.8%

Most occurring characters

Value	Count	Frequency (%)
9	5015301	39.4%
5	1800804	14.1%
0	1242655	9.8%
7	753631	5.9%
2	723438	5.7%
8	692186	5.4%
1	679700	5.3%
4	612600	4.8%
3	604036	4.7%
6	585516	4.6%
Other values (58)	33045	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12742912	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	5015301	39.4%
5	1800804	14.1%
0	1242655	9.8%
7	753631	5.9%
2	723438	5.7%
8	692186	5.4%
1	679700	5.3%
4	612600	4.8%
3	604036	4.7%
6	585516	4.6%
Other values (58)	33045	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12742912	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	5015301	39.4%
5	1800804	14.1%
0	1242655	9.8%
7	753631	5.9%
2	723438	5.7%
8	692186	5.4%
1	679700	5.3%
4	612600	4.8%
3	604036	4.7%
6	585516	4.6%
Other values (58)	33045	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12742912	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	5015301	39.4%
5	1800804	14.1%
0	1242655	9.8%
7	753631	5.9%
2	723438	5.7%
8	692186	5.4%
1	679700	5.3%
4	612600	4.8%
3	604036	4.7%
6	585516	4.6%
Other values (58)	33045	0.3%

pdv_id
Text

Distinct	12689
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	39.0 MiB

Length

Max length	8
Median length	7
Mean length	6.69813303
Min length	1

Characters and Unicode

Total characters	4915512
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	646 ?
Unique (%)	0.1%

Sample

1st row	D48
2nd row	P347521
3rd row	P665565
4th row	P966630
5th row	P954533

Value	Count	Frequency (%)
p326910	5523	0.8%
p144920	4842	0.7%
p948936	4384	0.6%
dh7	3466	0.5%
p193926	3179	0.4%
p896969	3069	0.4%
p287979	2941	0.4%
p240569	2855	0.4%
p839536	2840	0.4%
p544533	2835	0.4%
Other values (12664)	698483	95.1%

Most occurring characters

Value	Count	Frequency (%)
5	678957	13.8%
P	673382	13.7%
9	636276	12.9%
6	491065	10.0%
3	486653	9.9%
2	444890	9.1%
4	305566	6.2%
8	298483	6.1%
7	278437	5.7%
0	275557	5.6%
Other values (12)	346246	7.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4915512	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	678957	13.8%
P	673382	13.7%
9	636276	12.9%
6	491065	10.0%
3	486653	9.9%
2	444890	9.1%
4	305566	6.2%
8	298483	6.1%
7	278437	5.7%
0	275557	5.6%
Other values (12)	346246	7.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4915512	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	678957	13.8%
P	673382	13.7%
9	636276	12.9%
6	491065	10.0%
3	486653	9.9%
2	444890	9.1%
4	305566	6.2%
8	298483	6.1%
7	278437	5.7%
0	275557	5.6%
Other values (12)	346246	7.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4915512	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	678957	13.8%
P	673382	13.7%
9	636276	12.9%
6	491065	10.0%
3	486653	9.9%
2	444890	9.1%
4	305566	6.2%
8	298483	6.1%
7	278437	5.7%
0	275557	5.6%
Other values (12)	346246	7.0%

pdv_wilaya
Text

Distinct	106
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.1 MiB

Length

Max length	21
Median length	19
Mean length	9.423129385
Min length	1

Characters and Unicode

Total characters	6915286
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Algiers
2nd row	07-BISKRA
3rd row	25-CONSTANTINE
4th row	30-OUARGLA
5th row	34-BORDJ-BOU-ARRERIDJ

Value	Count	Frequency (%)
16-alger	134911	18.0%
19-setif	50086	6.7%
25-constantine	49873	6.6%
09-blida	33434	4.5%
02-chlef	31829	4.2%
31-oran	31799	4.2%
35-boumerdes	30294	4.0%
17-djelfa	30082	4.0%
28-msila	29251	3.9%
26-medea	19721	2.6%
Other values (109)	309022	41.2%

Most occurring characters

Value	Count	Frequency (%)
-	755989	10.9%
A	650574	9.4%
E	570754	8.3%
L	355952	5.1%
I	330398	4.8%
R	309978	4.5%
1	307964	4.5%
N	261532	3.8%
S	242811	3.5%
T	238895	3.5%
Other values (52)	2890439	41.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6915286	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	755989	10.9%
A	650574	9.4%
E	570754	8.3%
L	355952	5.1%
I	330398	4.8%
R	309978	4.5%
1	307964	4.5%
N	261532	3.8%
S	242811	3.5%
T	238895	3.5%
Other values (52)	2890439	41.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6915286	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	755989	10.9%
A	650574	9.4%
E	570754	8.3%
L	355952	5.1%
I	330398	4.8%
R	309978	4.5%
1	307964	4.5%
N	261532	3.8%
S	242811	3.5%
T	238895	3.5%
Other values (52)	2890439	41.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6915286	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	755989	10.9%
A	650574	9.4%
E	570754	8.3%
L	355952	5.1%
I	330398	4.8%
R	309978	4.5%
1	307964	4.5%
N	261532	3.8%
S	242811	3.5%
T	238895	3.5%
Other values (52)	2890439	41.8%

status
Text

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.5 MiB

Length

Max length	10
Median length	6
Mean length	6.06400786
Min length	4

Characters and Unicode

Total characters	4450151
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Active
2nd row	Active
3rd row	Active
4th row	Active
5th row	Active

Value	Count	Frequency (%)
active	716611	97.6%
suspended	15897	2.2%
idle	1023	0.1%
terminated	332	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	750092	16.9%
t	716943	16.1%
i	716943	16.1%
A	716611	16.1%
c	716611	16.1%
v	716611	16.1%
d	33149	0.7%
n	16229	0.4%
S	15897	0.4%
u	15897	0.4%
Other values (8)	35168	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4450151	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	750092	16.9%
t	716943	16.1%
i	716943	16.1%
A	716611	16.1%
c	716611	16.1%
v	716611	16.1%
d	33149	0.7%
n	16229	0.4%
S	15897	0.4%
u	15897	0.4%
Other values (8)	35168	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4450151	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	750092	16.9%
t	716943	16.1%
i	716943	16.1%
A	716611	16.1%
c	716611	16.1%
v	716611	16.1%
d	33149	0.7%
n	16229	0.4%
S	15897	0.4%
u	15897	0.4%
Other values (8)	35168	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4450151	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	750092	16.9%
t	716943	16.1%
i	716943	16.1%
A	716611	16.1%
c	716611	16.1%
v	716611	16.1%
d	33149	0.7%
n	16229	0.4%
S	15897	0.4%
u	15897	0.4%
Other values (8)	35168	0.8%

customer_type
Text

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.3 MiB

Length

Max length	14
Median length	10
Mean length	9.994105167
Min length	8

Characters and Unicode

Total characters	7334304
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INDIVIDUAL
2nd row	INDIVIDUAL
3rd row	INDIVIDUAL
4th row	INDIVIDUAL
5th row	INDIVIDUAL

Value	Count	Frequency (%)
individual	731547	99.7%
business	2265	0.3%
non	51	< 0.1%
commercial	51	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
I	2196957	30.0%
D	1463094	19.9%
N	733914	10.0%
U	733812	10.0%
A	731598	10.0%
L	731598	10.0%
V	731547	10.0%
S	6795	0.1%
E	2316	< 0.1%
B	2265	< 0.1%
Other values (5)	408	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7334304	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	2196957	30.0%
D	1463094	19.9%
N	733914	10.0%
U	733812	10.0%
A	731598	10.0%
L	731598	10.0%
V	731547	10.0%
S	6795	0.1%
E	2316	< 0.1%
B	2265	< 0.1%
Other values (5)	408	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7334304	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	2196957	30.0%
D	1463094	19.9%
N	733914	10.0%
U	733812	10.0%
A	731598	10.0%
L	731598	10.0%
V	731547	10.0%
S	6795	0.1%
E	2316	< 0.1%
B	2265	< 0.1%
Other values (5)	408	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7334304	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	2196957	30.0%
D	1463094	19.9%
N	733914	10.0%
U	733812	10.0%
A	731598	10.0%
L	731598	10.0%
V	731547	10.0%
S	6795	0.1%
E	2316	< 0.1%
B	2265	< 0.1%
Other values (5)	408	< 0.1%

first_cdr_wilaya
Text

Distinct	59
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	35.5 MiB

Length

Max length	19
Median length	1
Mean length	1.773027118
Min length	1

Characters and Unicode

Total characters	1301159
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	?
2nd row	?
3rd row	?
4th row	?
5th row	?

Value	Count	Frequency (%)
	634083	86.0%
alger	25436	3.5%
setif	7169	1.0%
constantine	6526	0.9%
djelfa	6021	0.8%
blida	4293	0.6%
boumerdes	3917	0.5%
oran	3702	0.5%
medea	3228	0.4%
msila	2649	0.4%
Other values (56)	40228	5.5%

Most occurring characters

Value	Count	Frequency (%)
?	634083	48.7%
A	97479	7.5%
E	87608	6.7%
L	59458	4.6%
R	45555	3.5%
I	44174	3.4%
N	35373	2.7%
T	33594	2.6%
S	32778	2.5%
G	31324	2.4%
Other values (20)	199733	15.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1301159	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
?	634083	48.7%
A	97479	7.5%
E	87608	6.7%
L	59458	4.6%
R	45555	3.5%
I	44174	3.4%
N	35373	2.7%
T	33594	2.6%
S	32778	2.5%
G	31324	2.4%
Other values (20)	199733	15.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1301159	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
?	634083	48.7%
A	97479	7.5%
E	87608	6.7%
L	59458	4.6%
R	45555	3.5%
I	44174	3.4%
N	35373	2.7%
T	33594	2.6%
S	32778	2.5%
G	31324	2.4%
Other values (20)	199733	15.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1301159	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
?	634083	48.7%
A	97479	7.5%
E	87608	6.7%
L	59458	4.6%
R	45555	3.5%
I	44174	3.4%
N	35373	2.7%
T	33594	2.6%
S	32778	2.5%
G	31324	2.4%
Other values (20)	199733	15.4%

subscriber_wilaya_std
Text

Distinct	73
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.5 MiB

Length

Max length	19
Median length	18
Mean length	6.790851971
Min length	1

Characters and Unicode

Total characters	4983555
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	Alger
2nd row	Ouled Djellal
3rd row	Constantine
4th row	Ouargla
5th row	Bordj Bou Arreridj

Value	Count	Frequency (%)
alger	144199	17.1%
constantine	52621	6.3%
sétif	52303	6.2%
oran	35823	4.3%
chlef	34079	4.1%
blida	32901	3.9%
m'sila	30845	3.7%
djelfa	30188	3.6%
boumerdès	26949	3.2%
aïn	24483	2.9%
Other values (73)	376700	44.8%

Most occurring characters

Value	Count	Frequency (%)
a	505065	10.1%
e	450814	9.0%
l	418966	8.4%
r	315298	6.3%
i	308878	6.2%
n	288644	5.8%
t	205383	4.1%
A	196766	3.9%
g	171109	3.4%
o	159613	3.2%
Other values (42)	1963019	39.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4983555	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	505065	10.1%
e	450814	9.0%
l	418966	8.4%
r	315298	6.3%
i	308878	6.2%
n	288644	5.8%
t	205383	4.1%
A	196766	3.9%
g	171109	3.4%
o	159613	3.2%
Other values (42)	1963019	39.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4983555	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	505065	10.1%
e	450814	9.0%
l	418966	8.4%
r	315298	6.3%
i	308878	6.2%
n	288644	5.8%
t	205383	4.1%
A	196766	3.9%
g	171109	3.4%
o	159613	3.2%
Other values (42)	1963019	39.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4983555	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	505065	10.1%
e	450814	9.0%
l	418966	8.4%
r	315298	6.3%
i	308878	6.2%
n	288644	5.8%
t	205383	4.1%
A	196766	3.9%
g	171109	3.4%
o	159613	3.2%
Other values (42)	1963019	39.4%

pdv_wilaya_std
Text

Distinct	58
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.4 MiB

Length

Max length	19
Median length	18
Mean length	6.671701666
Min length	4

Characters and Unicode

Total characters	4896115
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Alger
2nd row	Biskra
3rd row	Constantine
4th row	Ouargla
5th row	Bordj Bou Arreridj

Value	Count	Frequency (%)
alger	148743	18.0%
constantine	53152	6.4%
sétif	52240	6.3%
oran	37792	4.6%
blida	35641	4.3%
chlef	32804	4.0%
djelfa	30747	3.7%
boumerdès	30740	3.7%
m'sila	30197	3.6%
aïn	23591	2.8%
Other values (60)	352474	42.6%

Most occurring characters

Value	Count	Frequency (%)
a	498864	10.2%
e	434126	8.9%
l	384269	7.8%
r	330065	6.7%
i	311362	6.4%
n	288294	5.9%
t	202345	4.1%
A	199680	4.1%
g	174423	3.6%
B	164938	3.4%
Other values (37)	1907749	39.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4896115	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	498864	10.2%
e	434126	8.9%
l	384269	7.8%
r	330065	6.7%
i	311362	6.4%
n	288294	5.9%
t	202345	4.1%
A	199680	4.1%
g	174423	3.6%
B	164938	3.4%
Other values (37)	1907749	39.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4896115	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	498864	10.2%
e	434126	8.9%
l	384269	7.8%
r	330065	6.7%
i	311362	6.4%
n	288294	5.9%
t	202345	4.1%
A	199680	4.1%
g	174423	3.6%
B	164938	3.4%
Other values (37)	1907749	39.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4896115	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	498864	10.2%
e	434126	8.9%
l	384269	7.8%
r	330065	6.7%
i	311362	6.4%
n	288294	5.9%
t	202345	4.1%
A	199680	4.1%
g	174423	3.6%
B	164938	3.4%
Other values (37)	1907749	39.0%

subscriber_wilaya_code
Real number (ℝ)

Distinct	60
Distinct (%)	< 0.1%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	21.69939865

Minimum	0
Maximum	99
Zeros	90
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	16
median	19
Q3	28
95-th percentile	44
Maximum	99
Range	99
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	11.89623928
Coefficient of variation (CV)	0.5482289843
Kurtosis	-0.0306252935
Mean	21.69939865
Median Absolute Deviation (MAD)	7
Skewness	0.5660107938
Sum	15924082
Variance	141.5205091
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	144198	19.6%
25	52621	7.2%
19	52303	7.1%
31	35823	4.9%
2	34079	4.6%
9	32901	4.5%
28	30845	4.2%
17	30188	4.1%
35	26949	3.7%
26	20921	2.9%
Other values (50)	273021	37.2%

Value	Count	Frequency (%)
0	90	< 0.1%
1	1329	0.2%
2	34079	4.6%
3	2670	0.4%
4	8880	1.2%

Value	Count	Frequency (%)
99	36	< 0.1%
58	306	< 0.1%
57	1526	0.2%
56	115	< 0.1%
55	1407	0.2%

pdv_wilaya_code
Real number (ℝ)

Distinct	58
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.96676491

Minimum	0
Maximum	58
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	16
median	19
Q3	28
95-th percentile	44
Maximum	58
Range	58
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	11.17824321
Coefficient of variation (CV)	0.5331410569
Kurtosis	-0.2824807568
Mean	20.96676491
Median Absolute Deviation (MAD)	7
Skewness	0.4458844056
Sum	15386733
Variance	124.9531212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	148743	20.3%
25	53152	7.2%
19	52240	7.1%
31	37792	5.1%
9	35641	4.9%
2	32804	4.5%
17	30747	4.2%
35	30740	4.2%
28	30197	4.1%
26	20565	2.8%
Other values (48)	261242	35.6%

Value	Count	Frequency (%)
0	1	< 0.1%
1	1569	0.2%
2	32804	4.5%
3	2732	0.4%
4	8699	1.2%

Value	Count	Frequency (%)
58	189	< 0.1%
57	174	< 0.1%
56	100	< 0.1%
54	148	< 0.1%
53	126	< 0.1%

activation_hour
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.6471385

Minimum	0
Maximum	23
Zeros	6009
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	12
median	16
Q3	19
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.165197699
Coefficient of variation (CV)	0.2661954899
Kurtosis	0.5974994701
Mean	15.6471385
Median Absolute Deviation (MAD)	3
Skewness	-0.5390217014
Sum	11482856
Variance	17.34887187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
17	82413	11.2%
18	63913	8.7%
16	61173	8.3%
15	56332	7.7%
11	52814	7.2%
14	52074	7.1%
19	48665	6.6%
12	48062	6.5%
21	47198	6.4%
20	46981	6.4%
Other values (14)	174238	23.7%

Value	Count	Frequency (%)
0	6009	0.8%
1	1863	0.3%
2	497	0.1%
3	93	< 0.1%
4	60	< 0.1%

Value	Count	Frequency (%)
23	16554	2.3%
22	34329	4.7%
21	47198	6.4%
20	46981	6.4%
19	48665	6.6%

activation_dayofweek
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.009771579

Minimum	0
Maximum	6
Zeros	109831
Zeros (%)	15.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.017180449
Coefficient of variation (CV)	0.6702104783
Kurtosis	-1.222791261
Mean	3.009771579
Median Absolute Deviation (MAD)	2
Skewness	-0.001162837344
Sum	2208760
Variance	4.069016965
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	124607	17.0%
6	119254	16.3%
0	109831	15.0%
3	109141	14.9%
1	100860	13.7%
2	94775	12.9%
5	75395	10.3%

Value	Count	Frequency (%)
0	109831	15.0%
1	100860	13.7%
2	94775	12.9%
3	109141	14.9%
4	124607	17.0%

Value	Count	Frequency (%)
6	119254	16.3%
5	75395	10.3%
4	124607	17.0%
3	109141	14.9%
2	94775	12.9%

activation_month
Real number (ℝ)

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.195886698

Minimum	1
Maximum	4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	4
Maximum	4
Range	3
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9192218523
Coefficient of variation (CV)	0.418610784
Kurtosis	-0.9318852824
Mean	2.195886698
Median Absolute Deviation (MAD)	1
Skewness	0.1829677786
Sum	1611480
Variance	0.8449688137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
2	250841	34.2%
3	230774	31.4%
1	197172	26.9%
4	55076	7.5%

Value	Count	Frequency (%)
1	197172	26.9%
2	250841	34.2%
3	230774	31.4%
4	55076	7.5%

Value	Count	Frequency (%)
4	55076	7.5%
3	230774	31.4%
2	250841	34.2%
1	197172	26.9%

activation_week
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.170488225

Minimum	2
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	5
median	8
Q3	11
95-th percentile	14
Maximum	15
Range	13
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.648526519
Coefficient of variation (CV)	0.4465493883
Kurtosis	-1.137888382
Mean	8.170488225
Median Absolute Deviation (MAD)	3
Skewness	0.04959208318
Sum	5996019
Variance	13.31174576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
9	76252	10.4%
5	68015	9.3%
13	64004	8.7%
8	62000	8.4%
7	56999	7.8%
3	56911	7.8%
6	55974	7.6%
4	54504	7.4%
12	52688	7.2%
14	50933	6.9%
Other values (4)	135583	18.5%

Value	Count	Frequency (%)
2	33993	4.6%
3	56911	7.8%
4	54504	7.4%
5	68015	9.3%
6	55974	7.6%

Value	Count	Frequency (%)
15	8761	1.2%
14	50933	6.9%
13	64004	8.7%
12	52688	7.2%
11	45029	6.1%

time_phase
Text

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.8 MiB

Length

Max length	9
Median length	7
Mean length	7.920981164
Min length	5

Characters and Unicode

Total characters	5812915
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Morning
2nd row	Morning
3rd row	Evening
4th row	Morning
5th row	Afternoon

Value	Count	Frequency (%)
afternoon	340539	46.4%
evening	263649	35.9%
morning	127073	17.3%
night	2602	0.4%

Most occurring characters

Value	Count	Frequency (%)
n	1462522	25.2%
o	808151	13.9%
e	604188	10.4%
r	467612	8.0%
i	393324	6.8%
g	393324	6.8%
t	343141	5.9%
f	340539	5.9%
A	340539	5.9%
E	263649	4.5%
Other values (4)	395926	6.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5812915	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	1462522	25.2%
o	808151	13.9%
e	604188	10.4%
r	467612	8.0%
i	393324	6.8%
g	393324	6.8%
t	343141	5.9%
f	340539	5.9%
A	340539	5.9%
E	263649	4.5%
Other values (4)	395926	6.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5812915	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	1462522	25.2%
o	808151	13.9%
e	604188	10.4%
r	467612	8.0%
i	393324	6.8%
g	393324	6.8%
t	343141	5.9%
f	340539	5.9%
A	340539	5.9%
E	263649	4.5%
Other values (4)	395926	6.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5812915	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	1462522	25.2%
o	808151	13.9%
e	604188	10.4%
r	467612	8.0%
i	393324	6.8%
g	393324	6.8%
t	343141	5.9%
f	340539	5.9%
A	340539	5.9%
E	263649	4.5%
Other values (4)	395926	6.8%

same_wilaya
Real number (ℝ)

Zeros

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9063149389

Minimum	0
Maximum	1
Zeros	68752
Zeros (%)	9.4%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2913902643
Coefficient of variation (CV)	0.3215110463
Kurtosis	5.777477142
Mean	0.9063149389
Median Absolute Deviation (MAD)	0
Skewness	-2.788810032
Sum	665111
Variance	0.08490828613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=2)

Value	Count	Frequency (%)
1	665111	90.6%
0	68752	9.4%

Value	Count	Frequency (%)
0	68752	9.4%
1	665111	90.6%

Value	Count	Frequency (%)
1	665111	90.6%
0	68752	9.4%

wilaya_code_diff
Real number (ℝ)

Zeros

Distinct	64
Distinct (%)	< 0.1%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.816282369

Minimum	0
Maximum	87
Zeros	665111
Zeros (%)	90.6%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	15
Maximum	87
Range	87
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.091319635
Coefficient of variation (CV)	3.904304616
Kurtosis	21.90790621
Mean	1.816282369
Median Absolute Deviation (MAD)	0
Skewness	4.591364429
Sum	1332877
Variance	50.28681417
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	665111	90.6%
44	9534	1.3%
7	4890	0.7%
19	4712	0.6%
3	3176	0.4%
18	2900	0.4%
10	2748	0.4%
2	2662	0.4%
1	2360	0.3%
25	2215	0.3%
Other values (54)	33541	4.6%

Value	Count	Frequency (%)
0	665111	90.6%
1	2360	0.3%
2	2662	0.4%
3	3176	0.4%
4	1673	0.2%

Value	Count	Frequency (%)
87	4	< 0.1%
83	7	< 0.1%
80	6	< 0.1%
78	8	< 0.1%
71	6	< 0.1%

pdv_activation_count
Real number (ℝ)

Distinct	931
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1133.254459

Minimum	1
Maximum	10846
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	1
5-th percentile	29
Q1	131
median	440
Q3	1349
95-th percentile	5350
Maximum	10846
Range	10845
Interquartile range (IQR)	1218

Descriptive statistics

Standard deviation	1796.797711
Coefficient of variation (CV)	1.585520089
Kurtosis	10.75911886
Mean	1133.254459
Median Absolute Deviation (MAD)	377
Skewness	3.062936257
Sum	831653517
Variance	3228482.014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10846	5523	0.8%
9717	4842	0.7%
8715	4384	0.6%
6864	3466	0.5%
6270	3179	0.4%
5925	3069	0.4%
5722	2941	0.4%
5673	2855	0.4%
5578	2840	0.4%
5511	2835	0.4%
Other values (921)	697929	95.1%

Value	Count	Frequency (%)
1	161	< 0.1%
2	389	0.1%
3	573	0.1%
4	602	0.1%
5	758	0.1%

Value	Count	Frequency (%)
10846	5523	0.8%
9717	4842	0.7%
8715	4384	0.6%
6864	3466	0.5%
6270	3179	0.4%

days_since_pdv_first_activation
Real number (ℝ)

Zeros

Distinct	90
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.20767636

Minimum	0
Maximum	89
Zeros	15549
Zeros (%)	2.1%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	20
median	41
Q3	64
95-th percentile	84
Maximum	89
Range	89
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	25.66268689
Coefficient of variation (CV)	0.6080099429
Kurtosis	-1.141257205
Mean	42.20767636
Median Absolute Deviation (MAD)	22
Skewness	0.1104147927
Sum	30974652
Variance	658.5734987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15549	2.1%
22	12280	1.7%
50	12128	1.7%
21	11796	1.6%
49	11218	1.5%
51	11059	1.5%
80	10264	1.4%
81	10166	1.4%
48	10089	1.4%
43	10066	1.4%
Other values (80)	619248	84.4%

Value	Count	Frequency (%)
0	15549	2.1%
1	7890	1.1%
2	6295	0.9%
3	8521	1.2%
4	8300	1.1%

Value	Count	Frequency (%)
89	4932	0.7%
88	7058	1.0%
87	8462	1.2%
86	5966	0.8%
85	6978	1.0%

time_phase_code
Real number (ℝ)

Zeros

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.193196823

Minimum	0
Maximum	3
Zeros	127073
Zeros (%)	17.3%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	2
Maximum	3
Range	3
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7136360006
Coefficient of variation (CV)	0.5980874127
Kurtosis	-0.9116410557
Mean	1.193196823
Median Absolute Deviation (MAD)	1
Skewness	-0.2418905358
Sum	875643
Variance	0.5092763414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
1	340539	46.4%
2	263649	35.9%
0	127073	17.3%
3	2602	0.4%

Value	Count	Frequency (%)
0	127073	17.3%
1	340539	46.4%
2	263649	35.9%
3	2602	0.4%

Value	Count	Frequency (%)
3	2602	0.4%
2	263649	35.9%
1	340539	46.4%
0	127073	17.3%

subscriber_sim_count
Real number (ℝ)

Skewed

Distinct	57
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.291136084

Minimum	1
Maximum	1745
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	1745
Range	1744
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	61.95629085
Coefficient of variation (CV)	14.43820229
Kurtosis	766.9002614
Mean	4.291136084
Median Absolute Deviation (MAD)	0
Skewness	27.53600142
Sum	3149106
Variance	3838.581975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	414755	56.5%
2	145786	19.9%
3	98912	13.5%
4	37272	5.1%
5	18327	2.5%
6	8843	1.2%
7	3235	0.4%
8	1504	0.2%
1745	905	0.1%
9	725	0.1%
Other values (47)	3599	0.5%

Value	Count	Frequency (%)
1	414755	56.5%
2	145786	19.9%
3	98912	13.5%
4	37272	5.1%
5	18327	2.5%

Value	Count	Frequency (%)
1745	905	0.1%
500	264	< 0.1%
120	68	< 0.1%
102	50	< 0.1%
92	46	< 0.1%

pdv_total_activations
Real number (ℝ)

Distinct	931
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1133.254459

Minimum	1
Maximum	10846
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	1
5-th percentile	29
Q1	131
median	440
Q3	1349
95-th percentile	5350
Maximum	10846
Range	10845
Interquartile range (IQR)	1218

Descriptive statistics

Standard deviation	1796.797711
Coefficient of variation (CV)	1.585520089
Kurtosis	10.75911886
Mean	1133.254459
Median Absolute Deviation (MAD)	377
Skewness	3.062936257
Sum	831653517
Variance	3228482.014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10846	5523	0.8%
9717	4842	0.7%
8715	4384	0.6%
6864	3466	0.5%
6270	3179	0.4%
5925	3069	0.4%
5722	2941	0.4%
5673	2855	0.4%
5578	2840	0.4%
5511	2835	0.4%
Other values (921)	697929	95.1%

Value	Count	Frequency (%)
1	161	< 0.1%
2	389	0.1%
3	573	0.1%
4	602	0.1%
5	758	0.1%

Value	Count	Frequency (%)
10846	5523	0.8%
9717	4842	0.7%
8715	4384	0.6%
6864	3466	0.5%
6270	3179	0.4%

pdv_unique_customers
Real number (ℝ)

Distinct	821
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	840.2472355

Minimum	1
Maximum	6726
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	1
5-th percentile	27
Q1	112
median	354
Q3	1097
95-th percentile	3428
Maximum	6726
Range	6725
Interquartile range (IQR)	985

Descriptive statistics

Standard deviation	1236.895147
Coefficient of variation (CV)	1.472060953
Kurtosis	8.475910123
Mean	840.2472355
Median Absolute Deviation (MAD)	295
Skewness	2.76374274
Sum	616626357
Variance	1529909.604
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6726	5523	0.8%
6339	4842	0.7%
6199	4384	0.6%
5938	3466	0.5%
3860	3179	0.4%
3842	3069	0.4%
4343	2941	0.4%
4533	2855	0.4%
3894	2840	0.4%
3428	2835	0.4%
Other values (811)	697929	95.1%

Value	Count	Frequency (%)
1	233	< 0.1%
2	430	0.1%
3	644	0.1%
4	675	0.1%
5	859	0.1%

Value	Count	Frequency (%)
6726	5523	0.8%
6339	4842	0.7%
6199	4384	0.6%
5938	3466	0.5%
4533	2855	0.4%

pdv_avg_sims_per_customer
Real number (ℝ)

Skewed

Distinct	2634
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.299711143

Minimum	1
Maximum	29.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1.025672372
Q1	1.091370558
median	1.192307692
Q3	1.328358209
95-th percentile	1.60764294
Maximum	29.6
Range	28.6
Interquartile range (IQR)	0.2369876506

Descriptive statistics

Standard deviation	1.288224596
Coefficient of variation (CV)	0.9911622309
Kurtosis	438.9347381
Mean	1.299711143
Median Absolute Deviation (MAD)	0.114959626
Skewness	20.48589947
Sum	953809.9186
Variance	1.65952261
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	24230	3.3%
1.61254832	5523	0.8%
1.532891623	4842	0.7%
1.405871915	4384	0.6%
1.155944763	3466	0.5%
1.624352332	3179	0.4%
1.542165539	3069	0.4%
1.25	2958	0.4%
1.31752245	2941	0.4%
1.25148908	2855	0.4%
Other values (2624)	676416	92.2%

Value	Count	Frequency (%)
1	24230	3.3%
1.006896552	75	< 0.1%
1.007751938	58	< 0.1%
1.008196721	56	< 0.1%
1.00862069	56	< 0.1%

Value	Count	Frequency (%)
29.6	1370	0.2%
16.16666667	158	< 0.1%
15.4	32	< 0.1%
14.72222222	139	< 0.1%
8.516129032	262	< 0.1%

pdv_multi_sim_pct
Real number (ℝ)

Zeros

Distinct	2314
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.23109174

Minimum	0
Maximum	100
Zeros	24230
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	2.43902439
Q1	7.407407407
median	14.72184532
Q3	23.18181818
95-th percentile	35.26803708
Maximum	100
Range	100
Interquartile range (IQR)	15.77441077

Descriptive statistics

Standard deviation	10.94128893
Coefficient of variation (CV)	0.6740944541
Kurtosis	2.73558275
Mean	16.23109174
Median Absolute Deviation (MAD)	7.809749151
Skewness	1.101034708
Sum	11911397.68
Variance	119.7118034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	24230	3.3%
36.60422242	5523	0.8%
33.12825367	4842	0.7%
29.26278432	4384	0.6%
12.86628494	3466	0.5%
10	3267	0.4%
36.16580311	3179	0.4%
34.64341489	3069	0.4%
23.07160949	2941	0.4%
19.19258769	2855	0.4%
Other values (2304)	676107	92.1%

Value	Count	Frequency (%)
0	24230	3.3%
0.6896551724	75	< 0.1%
0.7751937984	58	< 0.1%
0.8196721311	56	< 0.1%
0.8474576271	59	< 0.1%

Value	Count	Frequency (%)
100	95	< 0.1%
91.66666667	13	< 0.1%
80	32	< 0.1%
77.77777778	297	< 0.1%
76.69565217	734	0.1%

reconstruction_error
Real number (ℝ)

Skewed

Distinct	424372
Distinct (%)	57.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.803216174

Minimum	0.0001709916412
Maximum	5744.21179
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0.0001709916412
5-th percentile	0.003809096105
Q1	0.00916532779
median	0.01625324746
Q3	0.02771710227
95-th percentile	0.07940948116
Maximum	5744.21179
Range	5744.211619
Interquartile range (IQR)	0.01855177448

Descriptive statistics

Standard deviation	189.7961793
Coefficient of variation (CV)	27.89800801
Kurtosis	806.0726272
Mean	6.803216174
Median Absolute Deviation (MAD)	0.008328934938
Skewness	28.40803767
Sum	4992628.631
Variance	36022.58968
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5365.131941	266	< 0.1%
5358.788618	139	< 0.1%
296.6560894	105	< 0.1%
5358.612766	99	< 0.1%
5362.388097	87	< 0.1%
5361.305609	62	< 0.1%
295.9920249	61	< 0.1%
5364.834484	59	< 0.1%
5703.806651	53	< 0.1%
5744.21179	53	< 0.1%
Other values (424362)	732879	99.9%

Value	Count	Frequency (%)
0.0001709916412	1	< 0.1%
0.0002323129427	1	< 0.1%
0.0002436047305	2	< 0.1%
0.0002756425174	1	< 0.1%
0.0002999267554	3	< 0.1%

Value	Count	Frequency (%)
5744.21179	53	< 0.1%
5703.806651	53	< 0.1%
5365.131941	266	< 0.1%
5364.834484	59	< 0.1%
5362.814672	27	< 0.1%

is_anomaly
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	716.8 KiB

False	722262
True	11601

Value	Count	Frequency (%)
False	722262	98.4%
True	11601	1.6%

Sample

	msisdn	activation_date	subscriber_wilaya	subscriber_id_number	pdv_id	pdv_wilaya	status	customer_type	first_cdr_wilaya	subscriber_wilaya_std	pdv_wilaya_std	subscriber_wilaya_code	pdv_wilaya_code	activation_hour	activation_dayofweek	activation_month	activation_week	time_phase	same_wilaya	wilaya_code_diff	pdv_activation_count	days_since_pdv_first_activation	time_phase_code	subscriber_sim_count	pdv_total_activations	pdv_unique_customers	pdv_avg_sims_per_customer	pdv_multi_sim_pct	reconstruction_error	is_anomaly
0	300010025	2025-01-29 10:56:38	ALGER	069182991590951419	D48	Algiers	Active	INDIVIDUAL	?	Alger	Alger	16.0	16	10	3	1	5	Morning	1	0.0	779	21	0	1	779	707	1.101839	8.769448	0.008248	False
1	300010038	2025-03-06 11:18:09	OULED-DJELLAL	59048923899923990	P347521	07-BISKRA	Active	INDIVIDUAL	?	Ouled Djellal	Biskra	51.0	7	11	4	3	10	Morning	0	44.0	2365	57	0	1	2365	1653	1.430732	29.280097	0.050278	False
2	300010052	2025-03-14 22:48:23	CONSTANTINE	109778991590927189	P665565	25-CONSTANTINE	Active	INDIVIDUAL	?	Constantine	Constantine	25.0	25	22	5	3	11	Evening	1	0.0	1581	53	2	1	1581	1126	1.404085	28.863233	0.018609	False
3	300010075	2025-02-22 11:54:44	OUARGLA	715903991550999329	P966630	30-OUARGLA	Active	INDIVIDUAL	?	Ouargla	Ouargla	30.0	30	11	6	2	8	Morning	1	0.0	29	41	0	1	29	29	1.000000	0.000000	0.037596	False
4	300010082	2025-02-02 14:36:33	BORDJ-BOU-ARRERIDJ	965546992559917639	P954533	34-BORDJ-BOU-ARRERIDJ	Active	INDIVIDUAL	?	Bordj Bou Arreridj	Bordj Bou Arreridj	34.0	34	14	0	2	5	Afternoon	1	0.0	374	24	1	1	374	313	1.194888	15.654952	0.011609	False

	msisdn	activation_date	subscriber_wilaya	subscriber_id_number	pdv_id	pdv_wilaya	status	customer_type	first_cdr_wilaya	subscriber_wilaya_std	pdv_wilaya_std	subscriber_wilaya_code	pdv_wilaya_code	activation_hour	activation_dayofweek	activation_month	activation_week	time_phase	same_wilaya	wilaya_code_diff	pdv_activation_count	days_since_pdv_first_activation	time_phase_code	subscriber_sim_count	pdv_total_activations	pdv_unique_customers	pdv_avg_sims_per_customer	pdv_multi_sim_pct	reconstruction_error	is_anomaly
733858	349740574	2025-01-19 17:23:39	OUARGLA	859385291290995259	D28	Ouargla	Active	INDIVIDUAL	?	Ouargla	Ouargla	30.0	30	17	0	1	3	Afternoon	1	0.0	635	11	1	1	635	607	1.046129	4.283361	0.016321	False
733859	349740602	2025-01-20 20:09:36	TOUGGOURT	825591998590925279	P669979	30-OUARGLA	Active	INDIVIDUAL	?	Touggourt	Ouargla	55.0	30	20	1	1	4	Evening	0	25.0	16	3	2	1	16	16	1.000000	0.000000	0.030959	False
733860	349740608	2025-02-17 19:09:34	CHLEF	089949999290995439	P736536	42-TIPAZA	Active	INDIVIDUAL	TIPAZA	Chlef	Tipaza	2.0	42	19	1	2	8	Evening	0	40.0	268	40	2	2	268	207	1.294686	22.222222	0.052666	False
733861	349740612	2025-02-25 15:09:13	ORAN	875559994520989549	P173940	31-ORAN	Active	INDIVIDUAL	?	Oran	Oran	31.0	31	15	2	2	9	Afternoon	1	0.0	359	48	1	2	359	336	1.068452	5.952381	0.006285	False
733862	349740621	2025-01-08 11:45:10	SKIKDA	099841995590922199	P785692	41-SOUK-AHRAS	Active	INDIVIDUAL	?	Skikda	Souk Ahras	21.0	41	11	3	1	2	Morning	0	20.0	46	0	0	1	46	43	1.069767	6.976744	0.023883	False

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks